﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsKhuyenMai" targetNamespace="http://tempuri.org/DsKhuyenMai.xsd" xmlns:mstns="http://tempuri.org/DsKhuyenMai.xsd" xmlns="http://tempuri.org/DsKhuyenMai.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="HuyHoangSGConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HuyHoangSGConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KhuyenMai.Properties.Settings.GlobalReference.Default.HuyHoangSGConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="HuyHoangNHConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HuyHoangNHConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.KhuyenMai.Properties.Settings.GlobalReference.Default.HuyHoangNHConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DoiTuongKhuyenMaiTableAdapter" GeneratorDataComponentClassName="DoiTuongKhuyenMaiTableAdapter" Name="DoiTuongKhuyenMai" UserDataComponentName="DoiTuongKhuyenMaiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HuyHoangNHConnectionString (Settings)" DbObjectName="HuyHoangNH.dbo.DoiTuongKhuyenMai" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [DoiTuongKhuyenMai] WHERE (([ChuongTrinhKhuyenMaiID] = @Original_ChuongTrinhKhuyenMaiID) AND ([DoiTuongNghiepVuID] = @Original_DoiTuongNghiepVuID) AND ((@IsNull_ThamGiaKhuyenMai = 1 AND [ThamGiaKhuyenMai] IS NULL) OR ([ThamGiaKhuyenMai] = @Original_ThamGiaKhuyenMai)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_DoiTuongNghiepVuID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DoiTuongNghiepVuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThamGiaKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThamGiaKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ThamGiaKhuyenMai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThamGiaKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [DoiTuongKhuyenMai] ([ChuongTrinhKhuyenMaiID], [DoiTuongNghiepVuID], [ThamGiaKhuyenMai]) VALUES (@ChuongTrinhKhuyenMaiID, @DoiTuongNghiepVuID, @ThamGiaKhuyenMai);
SELECT ChuongTrinhKhuyenMaiID, DoiTuongNghiepVuID, ThamGiaKhuyenMai FROM DoiTuongKhuyenMai WHERE (ChuongTrinhKhuyenMaiID = @ChuongTrinhKhuyenMaiID) AND (DoiTuongNghiepVuID = @DoiTuongNghiepVuID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@DoiTuongNghiepVuID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DoiTuongNghiepVuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ThamGiaKhuyenMai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThamGiaKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM DoiTuongKhuyenMai
</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [DoiTuongKhuyenMai] SET [ChuongTrinhKhuyenMaiID] = @ChuongTrinhKhuyenMaiID, [DoiTuongNghiepVuID] = @DoiTuongNghiepVuID, [ThamGiaKhuyenMai] = @ThamGiaKhuyenMai WHERE (([ChuongTrinhKhuyenMaiID] = @Original_ChuongTrinhKhuyenMaiID) AND ([DoiTuongNghiepVuID] = @Original_DoiTuongNghiepVuID) AND ((@IsNull_ThamGiaKhuyenMai = 1 AND [ThamGiaKhuyenMai] IS NULL) OR ([ThamGiaKhuyenMai] = @Original_ThamGiaKhuyenMai)));
SELECT ChuongTrinhKhuyenMaiID, DoiTuongNghiepVuID, ThamGiaKhuyenMai FROM DoiTuongKhuyenMai WHERE (ChuongTrinhKhuyenMaiID = @ChuongTrinhKhuyenMaiID) AND (DoiTuongNghiepVuID = @DoiTuongNghiepVuID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@DoiTuongNghiepVuID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DoiTuongNghiepVuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@ThamGiaKhuyenMai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThamGiaKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_DoiTuongNghiepVuID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="DoiTuongNghiepVuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThamGiaKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThamGiaKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_ThamGiaKhuyenMai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="ThamGiaKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ChuongTrinhKhuyenMaiID" DataSetColumn="ChuongTrinhKhuyenMaiID" />
              <Mapping SourceColumn="DoiTuongNghiepVuID" DataSetColumn="DoiTuongNghiepVuID" />
              <Mapping SourceColumn="ThamGiaKhuyenMai" DataSetColumn="ThamGiaKhuyenMai" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChiTietKhuyenMaiTheoThoiGianTableAdapter" GeneratorDataComponentClassName="ChiTietKhuyenMaiTheoThoiGianTableAdapter" Name="ChiTietKhuyenMaiTheoThoiGian" UserDataComponentName="ChiTietKhuyenMaiTheoThoiGianTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HuyHoangNHConnectionString (Settings)" DbObjectName="HuyHoangNH.dbo.ChiTietKhuyenMaiTheoThoiGian" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [ChiTietKhuyenMaiTheoThoiGian] WHERE (([ChuongTrinhKhuyenMaiID] = @Original_ChuongTrinhKhuyenMaiID) AND ([VatTuHangHoaID] = @Original_VatTuHangHoaID) AND ((@IsNull_ChietKhauKhuyenMai = 1 AND [ChietKhauKhuyenMai] IS NULL) OR ([ChietKhauKhuyenMai] = @Original_ChietKhauKhuyenMai)) AND ((@IsNull_GiaBanKhuyenMai = 1 AND [GiaBanKhuyenMai] IS NULL) OR ([GiaBanKhuyenMai] = @Original_GiaBanKhuyenMai)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_VatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="VatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBanKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBanKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBanKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [ChiTietKhuyenMaiTheoThoiGian] ([ChuongTrinhKhuyenMaiID], [VatTuHangHoaID], [ChietKhauKhuyenMai], [GiaBanKhuyenMai]) VALUES (@ChuongTrinhKhuyenMaiID, @VatTuHangHoaID, @ChietKhauKhuyenMai, @GiaBanKhuyenMai);
SELECT ChuongTrinhKhuyenMaiID, VatTuHangHoaID, ChietKhauKhuyenMai, GiaBanKhuyenMai FROM ChiTietKhuyenMaiTheoThoiGian WHERE (ChuongTrinhKhuyenMaiID = @ChuongTrinhKhuyenMaiID) AND (VatTuHangHoaID = @VatTuHangHoaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@VatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="VatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBanKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM ChiTietKhuyenMaiTheoThoiGian</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [ChiTietKhuyenMaiTheoThoiGian] SET [ChuongTrinhKhuyenMaiID] = @ChuongTrinhKhuyenMaiID, [VatTuHangHoaID] = @VatTuHangHoaID, [ChietKhauKhuyenMai] = @ChietKhauKhuyenMai, [GiaBanKhuyenMai] = @GiaBanKhuyenMai WHERE (([ChuongTrinhKhuyenMaiID] = @Original_ChuongTrinhKhuyenMaiID) AND ([VatTuHangHoaID] = @Original_VatTuHangHoaID) AND ((@IsNull_ChietKhauKhuyenMai = 1 AND [ChietKhauKhuyenMai] IS NULL) OR ([ChietKhauKhuyenMai] = @Original_ChietKhauKhuyenMai)) AND ((@IsNull_GiaBanKhuyenMai = 1 AND [GiaBanKhuyenMai] IS NULL) OR ([GiaBanKhuyenMai] = @Original_GiaBanKhuyenMai)));
SELECT ChuongTrinhKhuyenMaiID, VatTuHangHoaID, ChietKhauKhuyenMai, GiaBanKhuyenMai FROM ChiTietKhuyenMaiTheoThoiGian WHERE (ChuongTrinhKhuyenMaiID = @ChuongTrinhKhuyenMaiID) AND (VatTuHangHoaID = @VatTuHangHoaID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@VatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="VatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBanKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_VatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="VatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBanKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBanKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBanKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ChuongTrinhKhuyenMaiID" DataSetColumn="ChuongTrinhKhuyenMaiID" />
              <Mapping SourceColumn="VatTuHangHoaID" DataSetColumn="VatTuHangHoaID" />
              <Mapping SourceColumn="ChietKhauKhuyenMai" DataSetColumn="ChietKhauKhuyenMai" />
              <Mapping SourceColumn="GiaBanKhuyenMai" DataSetColumn="GiaBanKhuyenMai" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChuongTrinhKhuyenMaiTableAdapter" GeneratorDataComponentClassName="ChuongTrinhKhuyenMaiTableAdapter" Name="ChuongTrinhKhuyenMai" UserDataComponentName="ChuongTrinhKhuyenMaiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HuyHoangNHConnectionString (Settings)" DbObjectName="HuyHoangNH.dbo.ChuongTrinhKhuyenMai" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [ChuongTrinhKhuyenMai] WHERE (([ID] = @Original_ID) AND ((@IsNull_Ma = 1 AND [Ma] IS NULL) OR ([Ma] = @Original_Ma)) AND ((@IsNull_DienGiai = 1 AND [DienGiai] IS NULL) OR ([DienGiai] = @Original_DienGiai)) AND ((@IsNull_NgayBatDau = 1 AND [NgayBatDau] IS NULL) OR ([NgayBatDau] = @Original_NgayBatDau)) AND ((@IsNull_NgayKetThuc = 1 AND [NgayKetThuc] IS NULL) OR ([NgayKetThuc] = @Original_NgayKetThuc)) AND ((@IsNull_KieuKhuyenMai = 1 AND [KieuKhuyenMai] IS NULL) OR ([KieuKhuyenMai] = @Original_KieuKhuyenMai)) AND ((@IsNull_NgayTao = 1 AND [NgayTao] IS NULL) OR ([NgayTao] = @Original_NgayTao)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienGiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayBatDau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayBatDau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayBatDau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayKetThuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayKetThuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayKetThuc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayKetThuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KieuKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KieuKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KieuKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KieuKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayTao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayTao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayTao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayTao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [ChuongTrinhKhuyenMai] ([ID], [Ma], [DienGiai], [NgayBatDau], [NgayKetThuc], [KieuKhuyenMai], [NgayTao]) VALUES (@ID, @Ma, @DienGiai, @NgayBatDau, @NgayKetThuc, @KieuKhuyenMai, @NgayTao);
SELECT ID, Ma, DienGiai, NgayBatDau, NgayKetThuc, KieuKhuyenMai, NgayTao FROM ChuongTrinhKhuyenMai WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayBatDau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayKetThuc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayKetThuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KieuKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KieuKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayTao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayTao" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM ChuongTrinhKhuyenMai</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [ChuongTrinhKhuyenMai] SET [ID] = @ID, [Ma] = @Ma, [DienGiai] = @DienGiai, [NgayBatDau] = @NgayBatDau, [NgayKetThuc] = @NgayKetThuc, [KieuKhuyenMai] = @KieuKhuyenMai, [NgayTao] = @NgayTao WHERE (([ID] = @Original_ID) AND ((@IsNull_Ma = 1 AND [Ma] IS NULL) OR ([Ma] = @Original_Ma)) AND ((@IsNull_DienGiai = 1 AND [DienGiai] IS NULL) OR ([DienGiai] = @Original_DienGiai)) AND ((@IsNull_NgayBatDau = 1 AND [NgayBatDau] IS NULL) OR ([NgayBatDau] = @Original_NgayBatDau)) AND ((@IsNull_NgayKetThuc = 1 AND [NgayKetThuc] IS NULL) OR ([NgayKetThuc] = @Original_NgayKetThuc)) AND ((@IsNull_KieuKhuyenMai = 1 AND [KieuKhuyenMai] IS NULL) OR ([KieuKhuyenMai] = @Original_KieuKhuyenMai)) AND ((@IsNull_NgayTao = 1 AND [NgayTao] IS NULL) OR ([NgayTao] = @Original_NgayTao)));
SELECT ID, Ma, DienGiai, NgayBatDau, NgayKetThuc, KieuKhuyenMai, NgayTao FROM ChuongTrinhKhuyenMai WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayBatDau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayKetThuc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayKetThuc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KieuKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KieuKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@NgayTao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayTao" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ma" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DienGiai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DienGiai" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DienGiai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayBatDau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayBatDau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayBatDau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayBatDau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayKetThuc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayKetThuc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayKetThuc" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayKetThuc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KieuKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KieuKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KieuKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KieuKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgayTao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgayTao" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_NgayTao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="NgayTao" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Ma" DataSetColumn="Ma" />
              <Mapping SourceColumn="DienGiai" DataSetColumn="DienGiai" />
              <Mapping SourceColumn="NgayBatDau" DataSetColumn="NgayBatDau" />
              <Mapping SourceColumn="NgayKetThuc" DataSetColumn="NgayKetThuc" />
              <Mapping SourceColumn="KieuKhuyenMai" DataSetColumn="KieuKhuyenMai" />
              <Mapping SourceColumn="NgayTao" DataSetColumn="NgayTao" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ChiTietKhuyenMaiTheoTongTienTichLuyTableAdapter" GeneratorDataComponentClassName="ChiTietKhuyenMaiTheoTongTienTichLuyTableAdapter" Name="ChiTietKhuyenMaiTheoTongTienTichLuy" UserDataComponentName="ChiTietKhuyenMaiTheoTongTienTichLuyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HuyHoangNHConnectionString (Settings)" DbObjectName="HuyHoangNH.dbo.ChiTietKhuyenMaiTheoTongTienTichLuy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [ChiTietKhuyenMaiTheoTongTienTichLuy] WHERE (([ChuongTrinhKhuyenMaiID] = @Original_ChuongTrinhKhuyenMaiID) AND ([TongTienTu] = @Original_TongTienTu) AND ([TongTienDen] = @Original_TongTienDen) AND ((@IsNull_ChietKhauKhuyenMai = 1 AND [ChietKhauKhuyenMai] IS NULL) OR ([ChietKhauKhuyenMai] = @Original_ChietKhauKhuyenMai)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TongTienTu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienTu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TongTienDen" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienDen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [ChiTietKhuyenMaiTheoTongTienTichLuy] ([ChuongTrinhKhuyenMaiID], [TongTienTu], [TongTienDen], [ChietKhauKhuyenMai]) VALUES (@ChuongTrinhKhuyenMaiID, @TongTienTu, @TongTienDen, @ChietKhauKhuyenMai);
SELECT ChuongTrinhKhuyenMaiID, TongTienTu, TongTienDen, ChietKhauKhuyenMai FROM ChiTietKhuyenMaiTheoTongTienTichLuy WHERE (ChuongTrinhKhuyenMaiID = @ChuongTrinhKhuyenMaiID) AND (TongTienDen = @TongTienDen) AND (TongTienTu = @TongTienTu)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TongTienTu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienTu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TongTienDen" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienDen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT * FROM ChiTietKhuyenMaiTheoTongTienTichLuy</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [ChiTietKhuyenMaiTheoTongTienTichLuy] SET [ChuongTrinhKhuyenMaiID] = @ChuongTrinhKhuyenMaiID, [TongTienTu] = @TongTienTu, [TongTienDen] = @TongTienDen, [ChietKhauKhuyenMai] = @ChietKhauKhuyenMai WHERE (([ChuongTrinhKhuyenMaiID] = @Original_ChuongTrinhKhuyenMaiID) AND ([TongTienTu] = @Original_TongTienTu) AND ([TongTienDen] = @Original_TongTienDen) AND ((@IsNull_ChietKhauKhuyenMai = 1 AND [ChietKhauKhuyenMai] IS NULL) OR ([ChietKhauKhuyenMai] = @Original_ChietKhauKhuyenMai)));
SELECT ChuongTrinhKhuyenMaiID, TongTienTu, TongTienDen, ChietKhauKhuyenMai FROM ChiTietKhuyenMaiTheoTongTienTichLuy WHERE (ChuongTrinhKhuyenMaiID = @ChuongTrinhKhuyenMaiID) AND (TongTienDen = @TongTienDen) AND (TongTienTu = @TongTienTu)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TongTienTu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienTu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TongTienDen" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienDen" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ChuongTrinhKhuyenMaiID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ChuongTrinhKhuyenMaiID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TongTienTu" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienTu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_TongTienDen" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TongTienDen" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauKhuyenMai" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_ChietKhauKhuyenMai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ChietKhauKhuyenMai" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ChuongTrinhKhuyenMaiID" DataSetColumn="ChuongTrinhKhuyenMaiID" />
              <Mapping SourceColumn="TongTienTu" DataSetColumn="TongTienTu" />
              <Mapping SourceColumn="TongTienDen" DataSetColumn="TongTienDen" />
              <Mapping SourceColumn="ChietKhauKhuyenMai" DataSetColumn="ChietKhauKhuyenMai" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VatTuHangHoaTableAdapter" GeneratorDataComponentClassName="VatTuHangHoaTableAdapter" Name="VatTuHangHoa" UserDataComponentName="VatTuHangHoaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="HuyHoangNHConnectionString (Settings)" DbObjectName="HuyHoangNH.dbo.VatTuHangHoa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [VatTuHangHoa] WHERE (([ID] = @Original_ID) AND ([Ma] = @Original_Ma) AND ((@IsNull_Ten = 1 AND [Ten] IS NULL) OR ([Ten] = @Original_Ten)) AND ([DonViTinh] = @Original_DonViTinh) AND ((@IsNull_NhomVatTuHangHoaID = 1 AND [NhomVatTuHangHoaID] IS NULL) OR ([NhomVatTuHangHoaID] = @Original_NhomVatTuHangHoaID)) AND ([GiaMuaHienTai] = @Original_GiaMuaHienTai) AND ([GiaBanHienTai] = @Original_GiaBanHienTai) AND ((@IsNull_GiaBia = 1 AND [GiaBia] IS NULL) OR ([GiaBia] = @Original_GiaBia)) AND ((@IsNull_KhoMacDinhID = 1 AND [KhoMacDinhID] IS NULL) OR ([KhoMacDinhID] = @Original_KhoMacDinhID)) AND ((@IsNull_TacGia = 1 AND [TacGia] IS NULL) OR ([TacGia] = @Original_TacGia)) AND ((@IsNull_NhaXuatBan = 1 AND [NhaXuatBan] IS NULL) OR ([NhaXuatBan] = @Original_NhaXuatBan)) AND ([TrangThai] = @Original_TrangThai) AND ((@IsNull_GiaXuatKhoTamTinh = 1 AND [GiaXuatKhoTamTinh] IS NULL) OR ([GiaXuatKhoTamTinh] = @Original_GiaXuatKhoTamTinh)) AND ((@IsNull_LastUpdated = 1 AND [LastUpdated] IS NULL) OR ([LastUpdated] = @Original_LastUpdated)) AND ((@IsNull_NguonCungCap = 1 AND [NguonCungCap] IS NULL) OR ([NguonCungCap] = @Original_NguonCungCap)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)) AND ((@IsNull_ChietKhauBanLe = 1 AND [ChietKhauBanLe] IS NULL) OR ([ChietKhauBanLe] = @Original_ChietKhauBanLe)) AND ((@IsNull_ChietKhauMua = 1 AND [ChietKhauMua] IS NULL) OR ([ChietKhauMua] = @Original_ChietKhauMua)) AND ((@IsNull_ChietKhauBan = 1 AND [ChietKhauBan] IS NULL) OR ([ChietKhauBan] = @Original_ChietKhauBan)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhomVatTuHangHoaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TacGia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhaXuatBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaXuatKhoTamTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguonCungCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [VatTuHangHoa] ([ID], [Ma], [Ten], [DonViTinh], [NhomVatTuHangHoaID], [GiaMuaHienTai], [GiaBanHienTai], [GiaBia], [KhoMacDinhID], [TacGia], [NhaXuatBan], [TrangThai], [GiaXuatKhoTamTinh], [LastUpdated], [NguonCungCap], [GhiChu], [ChietKhauBanLe], [ChietKhauMua], [ChietKhauBan]) VALUES (@ID, @Ma, @Ten, @DonViTinh, @NhomVatTuHangHoaID, @GiaMuaHienTai, @GiaBanHienTai, @GiaBia, @KhoMacDinhID, @TacGia, @NhaXuatBan, @TrangThai, @GiaXuatKhoTamTinh, @LastUpdated, @NguonCungCap, @GhiChu, @ChietKhauBanLe, @ChietKhauMua, @ChietKhauBan);
SELECT CAST(0 AS bit) AS Choose, ID, Ma, Ten, DonViTinh, NhomVatTuHangHoaID, GiaMuaHienTai, GiaBanHienTai, GiaBia, KhoMacDinhID, TacGia, NhaXuatBan, TrangThai, GiaXuatKhoTamTinh, LastUpdated, NguonCungCap, GhiChu, ChietKhauBanLe, ChietKhauMua, ChietKhauBan FROM VatTuHangHoa WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CAST(0 AS bit) Choose, *
FROM VatTuHangHoa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [VatTuHangHoa] SET [ID] = @ID, [Ma] = @Ma, [Ten] = @Ten, [DonViTinh] = @DonViTinh, [NhomVatTuHangHoaID] = @NhomVatTuHangHoaID, [GiaMuaHienTai] = @GiaMuaHienTai, [GiaBanHienTai] = @GiaBanHienTai, [GiaBia] = @GiaBia, [KhoMacDinhID] = @KhoMacDinhID, [TacGia] = @TacGia, [NhaXuatBan] = @NhaXuatBan, [TrangThai] = @TrangThai, [GiaXuatKhoTamTinh] = @GiaXuatKhoTamTinh, [LastUpdated] = @LastUpdated, [NguonCungCap] = @NguonCungCap, [GhiChu] = @GhiChu, [ChietKhauBanLe] = @ChietKhauBanLe, [ChietKhauMua] = @ChietKhauMua, [ChietKhauBan] = @ChietKhauBan WHERE (([ID] = @Original_ID) AND ([Ma] = @Original_Ma) AND ((@IsNull_Ten = 1 AND [Ten] IS NULL) OR ([Ten] = @Original_Ten)) AND ([DonViTinh] = @Original_DonViTinh) AND ((@IsNull_NhomVatTuHangHoaID = 1 AND [NhomVatTuHangHoaID] IS NULL) OR ([NhomVatTuHangHoaID] = @Original_NhomVatTuHangHoaID)) AND ([GiaMuaHienTai] = @Original_GiaMuaHienTai) AND ([GiaBanHienTai] = @Original_GiaBanHienTai) AND ((@IsNull_GiaBia = 1 AND [GiaBia] IS NULL) OR ([GiaBia] = @Original_GiaBia)) AND ((@IsNull_KhoMacDinhID = 1 AND [KhoMacDinhID] IS NULL) OR ([KhoMacDinhID] = @Original_KhoMacDinhID)) AND ((@IsNull_TacGia = 1 AND [TacGia] IS NULL) OR ([TacGia] = @Original_TacGia)) AND ((@IsNull_NhaXuatBan = 1 AND [NhaXuatBan] IS NULL) OR ([NhaXuatBan] = @Original_NhaXuatBan)) AND ([TrangThai] = @Original_TrangThai) AND ((@IsNull_GiaXuatKhoTamTinh = 1 AND [GiaXuatKhoTamTinh] IS NULL) OR ([GiaXuatKhoTamTinh] = @Original_GiaXuatKhoTamTinh)) AND ((@IsNull_LastUpdated = 1 AND [LastUpdated] IS NULL) OR ([LastUpdated] = @Original_LastUpdated)) AND ((@IsNull_NguonCungCap = 1 AND [NguonCungCap] IS NULL) OR ([NguonCungCap] = @Original_NguonCungCap)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)) AND ((@IsNull_ChietKhauBanLe = 1 AND [ChietKhauBanLe] IS NULL) OR ([ChietKhauBanLe] = @Original_ChietKhauBanLe)) AND ((@IsNull_ChietKhauMua = 1 AND [ChietKhauMua] IS NULL) OR ([ChietKhauMua] = @Original_ChietKhauMua)) AND ((@IsNull_ChietKhauBan = 1 AND [ChietKhauBan] IS NULL) OR ([ChietKhauBan] = @Original_ChietKhauBan)));
SELECT CAST(0 AS bit) AS Choose, ID, Ma, Ten, DonViTinh, NhomVatTuHangHoaID, GiaMuaHienTai, GiaBanHienTai, GiaBia, KhoMacDinhID, TacGia, NhaXuatBan, TrangThai, GiaXuatKhoTamTinh, LastUpdated, NguonCungCap, GhiChu, ChietKhauBanLe, ChietKhauMua, ChietKhauBan FROM VatTuHangHoa WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ma" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ma" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ten" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Ten" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Ten" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DonViTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DonViTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhomVatTuHangHoaID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_NhomVatTuHangHoaID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NhomVatTuHangHoaID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaMuaHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaMuaHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBanHienTai" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBanHienTai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaBia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaBia" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaBia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KhoMacDinhID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KhoMacDinhID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TacGia" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TacGia" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TacGia" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NhaXuatBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NhaXuatBan" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NhaXuatBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_TrangThai" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="TrangThai" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GiaXuatKhoTamTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_GiaXuatKhoTamTinh" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="GiaXuatKhoTamTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NguonCungCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NguonCungCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NguonCungCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBanLe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBanLe" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauMua" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauMua" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ChietKhauBan" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChietKhauBan" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Choose" DataSetColumn="Choose" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Ma" DataSetColumn="Ma" />
              <Mapping SourceColumn="Ten" DataSetColumn="Ten" />
              <Mapping SourceColumn="DonViTinh" DataSetColumn="DonViTinh" />
              <Mapping SourceColumn="NhomVatTuHangHoaID" DataSetColumn="NhomVatTuHangHoaID" />
              <Mapping SourceColumn="GiaMuaHienTai" DataSetColumn="GiaMuaHienTai" />
              <Mapping SourceColumn="GiaBanHienTai" DataSetColumn="GiaBanHienTai" />
              <Mapping SourceColumn="GiaBia" DataSetColumn="GiaBia" />
              <Mapping SourceColumn="KhoMacDinhID" DataSetColumn="KhoMacDinhID" />
              <Mapping SourceColumn="TacGia" DataSetColumn="TacGia" />
              <Mapping SourceColumn="NhaXuatBan" DataSetColumn="NhaXuatBan" />
              <Mapping SourceColumn="TrangThai" DataSetColumn="TrangThai" />
              <Mapping SourceColumn="GiaXuatKhoTamTinh" DataSetColumn="GiaXuatKhoTamTinh" />
              <Mapping SourceColumn="LastUpdated" DataSetColumn="LastUpdated" />
              <Mapping SourceColumn="NguonCungCap" DataSetColumn="NguonCungCap" />
              <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
              <Mapping SourceColumn="ChietKhauBanLe" DataSetColumn="ChietKhauBanLe" />
              <Mapping SourceColumn="ChietKhauMua" DataSetColumn="ChietKhauMua" />
              <Mapping SourceColumn="ChietKhauBan" DataSetColumn="ChietKhauBan" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsKhuyenMai" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DsKhuyenMai" msprop:Generator_DataSetName="DsKhuyenMai" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DoiTuongKhuyenMai" msprop:Generator_UserTableName="DoiTuongKhuyenMai" msprop:Generator_RowDeletedName="DoiTuongKhuyenMaiRowDeleted" msprop:Generator_RowChangedName="DoiTuongKhuyenMaiRowChanged" msprop:Generator_RowClassName="DoiTuongKhuyenMaiRow" msprop:Generator_RowChangingName="DoiTuongKhuyenMaiRowChanging" msprop:Generator_RowEvArgName="DoiTuongKhuyenMaiRowChangeEvent" msprop:Generator_RowEvHandlerName="DoiTuongKhuyenMaiRowChangeEventHandler" msprop:Generator_TableClassName="DoiTuongKhuyenMaiDataTable" msprop:Generator_TableVarName="tableDoiTuongKhuyenMai" msprop:Generator_RowDeletingName="DoiTuongKhuyenMaiRowDeleting" msprop:Generator_TablePropName="DoiTuongKhuyenMai">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ChuongTrinhKhuyenMaiID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ChuongTrinhKhuyenMaiID" msprop:Generator_ColumnPropNameInRow="ChuongTrinhKhuyenMaiID" msprop:Generator_ColumnVarNameInTable="columnChuongTrinhKhuyenMaiID" msprop:Generator_ColumnPropNameInTable="ChuongTrinhKhuyenMaiIDColumn" type="xs:string" />
              <xs:element name="DoiTuongNghiepVuID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="DoiTuongNghiepVuID" msprop:Generator_ColumnPropNameInRow="DoiTuongNghiepVuID" msprop:Generator_ColumnVarNameInTable="columnDoiTuongNghiepVuID" msprop:Generator_ColumnPropNameInTable="DoiTuongNghiepVuIDColumn" type="xs:string" />
              <xs:element name="MaDoiTuong" msprop:Generator_UserColumnName="MaDoiTuong" msprop:Generator_ColumnPropNameInRow="MaDoiTuong" msprop:Generator_ColumnVarNameInTable="columnMaDoiTuong" msprop:Generator_ColumnPropNameInTable="MaDoiTuongColumn" type="xs:string" minOccurs="0" />
              <xs:element name="TenDoiTuong" msprop:Generator_UserColumnName="TenDoiTuong" msprop:Generator_ColumnPropNameInRow="TenDoiTuong" msprop:Generator_ColumnVarNameInTable="columnTenDoiTuong" msprop:Generator_ColumnPropNameInTable="TenDoiTuongColumn" type="xs:string" minOccurs="0" />
              <xs:element name="ThamGiaKhuyenMai" msprop:Generator_UserColumnName="ThamGiaKhuyenMai" msprop:Generator_ColumnPropNameInRow="ThamGiaKhuyenMai" msprop:Generator_ColumnVarNameInTable="columnThamGiaKhuyenMai" msprop:Generator_ColumnPropNameInTable="ThamGiaKhuyenMaiColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ChiTietKhuyenMaiTheoThoiGian" msprop:Generator_UserTableName="ChiTietKhuyenMaiTheoThoiGian" msprop:Generator_RowDeletedName="ChiTietKhuyenMaiTheoThoiGianRowDeleted" msprop:Generator_RowChangedName="ChiTietKhuyenMaiTheoThoiGianRowChanged" msprop:Generator_RowClassName="ChiTietKhuyenMaiTheoThoiGianRow" msprop:Generator_RowChangingName="ChiTietKhuyenMaiTheoThoiGianRowChanging" msprop:Generator_RowEvArgName="ChiTietKhuyenMaiTheoThoiGianRowChangeEvent" msprop:Generator_RowEvHandlerName="ChiTietKhuyenMaiTheoThoiGianRowChangeEventHandler" msprop:Generator_TableClassName="ChiTietKhuyenMaiTheoThoiGianDataTable" msprop:Generator_TableVarName="tableChiTietKhuyenMaiTheoThoiGian" msprop:Generator_RowDeletingName="ChiTietKhuyenMaiTheoThoiGianRowDeleting" msprop:Generator_TablePropName="ChiTietKhuyenMaiTheoThoiGian">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ChuongTrinhKhuyenMaiID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ChuongTrinhKhuyenMaiID" msprop:Generator_ColumnPropNameInRow="ChuongTrinhKhuyenMaiID" msprop:Generator_ColumnVarNameInTable="columnChuongTrinhKhuyenMaiID" msprop:Generator_ColumnPropNameInTable="ChuongTrinhKhuyenMaiIDColumn" type="xs:string" />
              <xs:element name="VatTuHangHoaID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="VatTuHangHoaID" msprop:Generator_ColumnPropNameInRow="VatTuHangHoaID" msprop:Generator_ColumnVarNameInTable="columnVatTuHangHoaID" msprop:Generator_ColumnPropNameInTable="VatTuHangHoaIDColumn" type="xs:string" />
              <xs:element name="MaHangHoa" msprop:Generator_UserColumnName="MaHangHoa" msprop:Generator_ColumnPropNameInRow="MaHangHoa" msprop:Generator_ColumnVarNameInTable="columnMaHangHoa" msprop:Generator_ColumnPropNameInTable="MaHangHoaColumn" type="xs:string" minOccurs="0" />
              <xs:element name="TenHangHoa" msprop:Generator_UserColumnName="TenHangHoa" msprop:Generator_ColumnPropNameInRow="TenHangHoa" msprop:Generator_ColumnVarNameInTable="columnTenHangHoa" msprop:Generator_ColumnPropNameInTable="TenHangHoaColumn" type="xs:string" minOccurs="0" />
              <xs:element name="GiaBia" msprop:Generator_UserColumnName="GiaBia" msprop:Generator_ColumnPropNameInRow="GiaBia" msprop:Generator_ColumnVarNameInTable="columnGiaBia" msprop:Generator_ColumnPropNameInTable="GiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChietKhauKhuyenMai" msprop:Generator_UserColumnName="ChietKhauKhuyenMai" msprop:Generator_ColumnPropNameInRow="ChietKhauKhuyenMai" msprop:Generator_ColumnVarNameInTable="columnChietKhauKhuyenMai" msprop:Generator_ColumnPropNameInTable="ChietKhauKhuyenMaiColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GiaBanKhuyenMai" msprop:Generator_UserColumnName="GiaBanKhuyenMai" msprop:Generator_ColumnPropNameInRow="GiaBanKhuyenMai" msprop:Generator_ColumnVarNameInTable="columnGiaBanKhuyenMai" msprop:Generator_ColumnPropNameInTable="GiaBanKhuyenMaiColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ChuongTrinhKhuyenMai" msprop:Generator_UserTableName="ChuongTrinhKhuyenMai" msprop:Generator_RowDeletedName="ChuongTrinhKhuyenMaiRowDeleted" msprop:Generator_RowChangedName="ChuongTrinhKhuyenMaiRowChanged" msprop:Generator_RowClassName="ChuongTrinhKhuyenMaiRow" msprop:Generator_RowChangingName="ChuongTrinhKhuyenMaiRowChanging" msprop:Generator_RowEvArgName="ChuongTrinhKhuyenMaiRowChangeEvent" msprop:Generator_RowEvHandlerName="ChuongTrinhKhuyenMaiRowChangeEventHandler" msprop:Generator_TableClassName="ChuongTrinhKhuyenMaiDataTable" msprop:Generator_TableVarName="tableChuongTrinhKhuyenMai" msprop:Generator_RowDeletingName="ChuongTrinhKhuyenMaiRowDeleting" msprop:Generator_TablePropName="ChuongTrinhKhuyenMai">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="Ma" msprop:Generator_UserColumnName="Ma" msprop:Generator_ColumnVarNameInTable="columnMa" msprop:Generator_ColumnPropNameInRow="Ma" msprop:Generator_ColumnPropNameInTable="MaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DienGiai" msprop:Generator_UserColumnName="DienGiai" msprop:Generator_ColumnVarNameInTable="columnDienGiai" msprop:Generator_ColumnPropNameInRow="DienGiai" msprop:Generator_ColumnPropNameInTable="DienGiaiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NgayBatDau" msprop:Generator_UserColumnName="NgayBatDau" msprop:Generator_ColumnVarNameInTable="columnNgayBatDau" msprop:Generator_ColumnPropNameInRow="NgayBatDau" msprop:Generator_ColumnPropNameInTable="NgayBatDauColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NgayKetThuc" msprop:Generator_UserColumnName="NgayKetThuc" msprop:Generator_ColumnVarNameInTable="columnNgayKetThuc" msprop:Generator_ColumnPropNameInRow="NgayKetThuc" msprop:Generator_ColumnPropNameInTable="NgayKetThucColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="KieuKhuyenMai" msprop:Generator_UserColumnName="KieuKhuyenMai" msprop:Generator_ColumnVarNameInTable="columnKieuKhuyenMai" msprop:Generator_ColumnPropNameInRow="KieuKhuyenMai" msprop:Generator_ColumnPropNameInTable="KieuKhuyenMaiColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NgayTao" msprop:Generator_UserColumnName="NgayTao" msprop:Generator_ColumnVarNameInTable="columnNgayTao" msprop:Generator_ColumnPropNameInRow="NgayTao" msprop:Generator_ColumnPropNameInTable="NgayTaoColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ChiTietKhuyenMaiTheoTongTienTichLuy" msprop:Generator_UserTableName="ChiTietKhuyenMaiTheoTongTienTichLuy" msprop:Generator_RowDeletedName="ChiTietKhuyenMaiTheoTongTienTichLuyRowDeleted" msprop:Generator_RowChangedName="ChiTietKhuyenMaiTheoTongTienTichLuyRowChanged" msprop:Generator_RowClassName="ChiTietKhuyenMaiTheoTongTienTichLuyRow" msprop:Generator_RowChangingName="ChiTietKhuyenMaiTheoTongTienTichLuyRowChanging" msprop:Generator_RowEvArgName="ChiTietKhuyenMaiTheoTongTienTichLuyRowChangeEvent" msprop:Generator_RowEvHandlerName="ChiTietKhuyenMaiTheoTongTienTichLuyRowChangeEventHandler" msprop:Generator_TableClassName="ChiTietKhuyenMaiTheoTongTienTichLuyDataTable" msprop:Generator_TableVarName="tableChiTietKhuyenMaiTheoTongTienTichLuy" msprop:Generator_RowDeletingName="ChiTietKhuyenMaiTheoTongTienTichLuyRowDeleting" msprop:Generator_TablePropName="ChiTietKhuyenMaiTheoTongTienTichLuy">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ChuongTrinhKhuyenMaiID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ChuongTrinhKhuyenMaiID" msprop:Generator_ColumnVarNameInTable="columnChuongTrinhKhuyenMaiID" msprop:Generator_ColumnPropNameInRow="ChuongTrinhKhuyenMaiID" msprop:Generator_ColumnPropNameInTable="ChuongTrinhKhuyenMaiIDColumn" type="xs:string" />
              <xs:element name="TongTienTu" msprop:Generator_UserColumnName="TongTienTu" msprop:Generator_ColumnVarNameInTable="columnTongTienTu" msprop:Generator_ColumnPropNameInRow="TongTienTu" msprop:Generator_ColumnPropNameInTable="TongTienTuColumn" type="xs:decimal" />
              <xs:element name="TongTienDen" msprop:Generator_UserColumnName="TongTienDen" msprop:Generator_ColumnVarNameInTable="columnTongTienDen" msprop:Generator_ColumnPropNameInRow="TongTienDen" msprop:Generator_ColumnPropNameInTable="TongTienDenColumn" type="xs:decimal" />
              <xs:element name="ChietKhauKhuyenMai" msprop:Generator_UserColumnName="ChietKhauKhuyenMai" msprop:Generator_ColumnVarNameInTable="columnChietKhauKhuyenMai" msprop:Generator_ColumnPropNameInRow="ChietKhauKhuyenMai" msprop:Generator_ColumnPropNameInTable="ChietKhauKhuyenMaiColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VatTuHangHoa" msprop:Generator_UserTableName="VatTuHangHoa" msprop:Generator_RowDeletedName="VatTuHangHoaRowDeleted" msprop:Generator_TableClassName="VatTuHangHoaDataTable" msprop:Generator_RowChangedName="VatTuHangHoaRowChanged" msprop:Generator_RowClassName="VatTuHangHoaRow" msprop:Generator_RowChangingName="VatTuHangHoaRowChanging" msprop:Generator_RowEvArgName="VatTuHangHoaRowChangeEvent" msprop:Generator_RowEvHandlerName="VatTuHangHoaRowChangeEventHandler" msprop:Generator_TablePropName="VatTuHangHoa" msprop:Generator_TableVarName="tableVatTuHangHoa" msprop:Generator_RowDeletingName="VatTuHangHoaRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Choose" msprop:Generator_UserColumnName="Choose" msprop:Generator_ColumnPropNameInRow="Choose" msprop:Generator_ColumnVarNameInTable="columnChoose" msprop:Generator_ColumnPropNameInTable="ChooseColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
              <xs:element name="Ma" msprop:Generator_UserColumnName="Ma" msprop:Generator_ColumnPropNameInRow="Ma" msprop:Generator_ColumnVarNameInTable="columnMa" msprop:Generator_ColumnPropNameInTable="MaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ten" msprop:Generator_UserColumnName="Ten" msprop:Generator_ColumnPropNameInRow="Ten" msprop:Generator_ColumnVarNameInTable="columnTen" msprop:Generator_ColumnPropNameInTable="TenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DonViTinh" msprop:Generator_UserColumnName="DonViTinh" msprop:Generator_ColumnPropNameInRow="DonViTinh" msprop:Generator_ColumnVarNameInTable="columnDonViTinh" msprop:Generator_ColumnPropNameInTable="DonViTinhColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NhomVatTuHangHoaID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="NhomVatTuHangHoaID" msprop:Generator_ColumnPropNameInRow="NhomVatTuHangHoaID" msprop:Generator_ColumnVarNameInTable="columnNhomVatTuHangHoaID" msprop:Generator_ColumnPropNameInTable="NhomVatTuHangHoaIDColumn" type="xs:string" minOccurs="0" />
              <xs:element name="GiaMuaHienTai" msprop:Generator_UserColumnName="GiaMuaHienTai" msprop:Generator_ColumnPropNameInRow="GiaMuaHienTai" msprop:Generator_ColumnVarNameInTable="columnGiaMuaHienTai" msprop:Generator_ColumnPropNameInTable="GiaMuaHienTaiColumn" type="xs:decimal" />
              <xs:element name="GiaBanHienTai" msprop:Generator_UserColumnName="GiaBanHienTai" msprop:Generator_ColumnPropNameInRow="GiaBanHienTai" msprop:Generator_ColumnVarNameInTable="columnGiaBanHienTai" msprop:Generator_ColumnPropNameInTable="GiaBanHienTaiColumn" type="xs:decimal" />
              <xs:element name="GiaBia" msprop:Generator_UserColumnName="GiaBia" msprop:Generator_ColumnPropNameInRow="GiaBia" msprop:Generator_ColumnVarNameInTable="columnGiaBia" msprop:Generator_ColumnPropNameInTable="GiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="KhoMacDinhID" msprop:Generator_UserColumnName="KhoMacDinhID" msprop:Generator_ColumnPropNameInRow="KhoMacDinhID" msprop:Generator_ColumnVarNameInTable="columnKhoMacDinhID" msprop:Generator_ColumnPropNameInTable="KhoMacDinhIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TacGia" msprop:Generator_UserColumnName="TacGia" msprop:Generator_ColumnPropNameInRow="TacGia" msprop:Generator_ColumnVarNameInTable="columnTacGia" msprop:Generator_ColumnPropNameInTable="TacGiaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NhaXuatBan" msprop:Generator_UserColumnName="NhaXuatBan" msprop:Generator_ColumnPropNameInRow="NhaXuatBan" msprop:Generator_ColumnVarNameInTable="columnNhaXuatBan" msprop:Generator_ColumnPropNameInTable="NhaXuatBanColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrangThai" msprop:Generator_UserColumnName="TrangThai" msprop:Generator_ColumnPropNameInRow="TrangThai" msprop:Generator_ColumnVarNameInTable="columnTrangThai" msprop:Generator_ColumnPropNameInTable="TrangThaiColumn" type="xs:boolean" />
              <xs:element name="GiaXuatKhoTamTinh" msprop:Generator_UserColumnName="GiaXuatKhoTamTinh" msprop:Generator_ColumnPropNameInRow="GiaXuatKhoTamTinh" msprop:Generator_ColumnVarNameInTable="columnGiaXuatKhoTamTinh" msprop:Generator_ColumnPropNameInTable="GiaXuatKhoTamTinhColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="LastUpdated" msprop:Generator_UserColumnName="LastUpdated" msprop:Generator_ColumnPropNameInRow="LastUpdated" msprop:Generator_ColumnVarNameInTable="columnLastUpdated" msprop:Generator_ColumnPropNameInTable="LastUpdatedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NguonCungCap" msprop:Generator_UserColumnName="NguonCungCap" msprop:Generator_ColumnPropNameInRow="NguonCungCap" msprop:Generator_ColumnVarNameInTable="columnNguonCungCap" msprop:Generator_ColumnPropNameInTable="NguonCungCapColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ChietKhauBanLe" msprop:Generator_UserColumnName="ChietKhauBanLe" msprop:Generator_ColumnPropNameInRow="ChietKhauBanLe" msprop:Generator_ColumnVarNameInTable="columnChietKhauBanLe" msprop:Generator_ColumnPropNameInTable="ChietKhauBanLeColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChietKhauMua" msprop:Generator_UserColumnName="ChietKhauMua" msprop:Generator_ColumnPropNameInRow="ChietKhauMua" msprop:Generator_ColumnVarNameInTable="columnChietKhauMua" msprop:Generator_ColumnPropNameInTable="ChietKhauMuaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChietKhauBan" msprop:Generator_UserColumnName="ChietKhauBan" msprop:Generator_ColumnPropNameInRow="ChietKhauBan" msprop:Generator_ColumnVarNameInTable="columnChietKhauBan" msprop:Generator_ColumnPropNameInTable="ChietKhauBanColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Detail_ThongKeHangBanKhuyenMai" msprop:Generator_UserTableName="Detail_ThongKeHangBanKhuyenMai" msprop:Generator_RowDeletedName="Detail_ThongKeHangBanKhuyenMaiRowDeleted" msprop:Generator_TableClassName="Detail_ThongKeHangBanKhuyenMaiDataTable" msprop:Generator_RowChangedName="Detail_ThongKeHangBanKhuyenMaiRowChanged" msprop:Generator_RowClassName="Detail_ThongKeHangBanKhuyenMaiRow" msprop:Generator_RowChangingName="Detail_ThongKeHangBanKhuyenMaiRowChanging" msprop:Generator_RowEvArgName="Detail_ThongKeHangBanKhuyenMaiRowChangeEvent" msprop:Generator_RowEvHandlerName="Detail_ThongKeHangBanKhuyenMaiRowChangeEventHandler" msprop:Generator_TablePropName="Detail_ThongKeHangBanKhuyenMai" msprop:Generator_TableVarName="tableDetail_ThongKeHangBanKhuyenMai" msprop:Generator_RowDeletingName="Detail_ThongKeHangBanKhuyenMaiRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="So" msprop:Generator_UserColumnName="So" msprop:Generator_ColumnPropNameInRow="So" msprop:Generator_ColumnVarNameInTable="columnSo" msprop:Generator_ColumnPropNameInTable="SoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Ngay" msprop:Generator_UserColumnName="Ngay" msprop:Generator_ColumnPropNameInRow="Ngay" msprop:Generator_ColumnVarNameInTable="columnNgay" msprop:Generator_ColumnPropNameInTable="NgayColumn" type="xs:dateTime" />
              <xs:element name="MaChuongTrinhKhuyenMai" msprop:Generator_UserColumnName="MaChuongTrinhKhuyenMai" msprop:Generator_ColumnPropNameInRow="MaChuongTrinhKhuyenMai" msprop:Generator_ColumnVarNameInTable="columnMaChuongTrinhKhuyenMai" msprop:Generator_ColumnPropNameInTable="MaChuongTrinhKhuyenMaiColumn" type="xs:string" minOccurs="0" />
              <xs:element name="TenDoiTac" msprop:Generator_UserColumnName="TenDoiTac" msprop:Generator_ColumnPropNameInRow="TenDoiTac" msprop:Generator_ColumnVarNameInTable="columnTenDoiTac" msprop:Generator_ColumnPropNameInTable="TenDoiTacColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenKho" msprop:Generator_UserColumnName="TenKho" msprop:Generator_ColumnPropNameInRow="TenKho" msprop:Generator_ColumnVarNameInTable="columnTenKho" msprop:Generator_ColumnPropNameInTable="TenKhoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenHangHoa" msprop:Generator_UserColumnName="TenHangHoa" msprop:Generator_ColumnPropNameInRow="TenHangHoa" msprop:Generator_ColumnVarNameInTable="columnTenHangHoa" msprop:Generator_ColumnPropNameInTable="TenHangHoaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TenNhomHangHoa" msprop:Generator_UserColumnName="TenNhomHangHoa" msprop:Generator_ColumnPropNameInRow="TenNhomHangHoa" msprop:Generator_ColumnVarNameInTable="columnTenNhomHangHoa" msprop:Generator_ColumnPropNameInTable="TenNhomHangHoaColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DonViTinh" msprop:Generator_UserColumnName="DonViTinh" msprop:Generator_ColumnPropNameInRow="DonViTinh" msprop:Generator_ColumnVarNameInTable="columnDonViTinh" msprop:Generator_ColumnPropNameInTable="DonViTinhColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoLuong" msprop:Generator_UserColumnName="SoLuong" msprop:Generator_ColumnPropNameInRow="SoLuong" msprop:Generator_ColumnVarNameInTable="columnSoLuong" msprop:Generator_ColumnPropNameInTable="SoLuongColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GiaBia" msprop:Generator_UserColumnName="GiaBia" msprop:Generator_ColumnPropNameInRow="GiaBia" msprop:Generator_ColumnVarNameInTable="columnGiaBia" msprop:Generator_ColumnPropNameInTable="GiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ThanhTienGiaBia" msprop:Generator_UserColumnName="ThanhTienGiaBia" msprop:Generator_ColumnPropNameInRow="ThanhTienGiaBia" msprop:Generator_ColumnVarNameInTable="columnThanhTienGiaBia" msprop:Generator_ColumnPropNameInTable="ThanhTienGiaBiaColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ChietKhau" msprop:Generator_UserColumnName="ChietKhau" msprop:Generator_ColumnPropNameInRow="ChietKhau" msprop:Generator_ColumnVarNameInTable="columnChietKhau" msprop:Generator_ColumnPropNameInTable="ChietKhauColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="GiaThanhToan" msprop:Generator_UserColumnName="GiaThanhToan" msprop:Generator_ColumnPropNameInRow="GiaThanhToan" msprop:Generator_ColumnVarNameInTable="columnGiaThanhToan" msprop:Generator_ColumnPropNameInTable="GiaThanhToanColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ThanhTienThanhToan" msprop:Generator_UserColumnName="ThanhTienThanhToan" msprop:Generator_ColumnPropNameInRow="ThanhTienThanhToan" msprop:Generator_ColumnVarNameInTable="columnThanhTienThanhToan" msprop:Generator_ColumnPropNameInTable="ThanhTienThanhToanColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="TongTienTheoHoaDon" msprop:Generator_UserColumnName="TongTienTheoHoaDon" msprop:Generator_ColumnPropNameInRow="TongTienTheoHoaDon" msprop:Generator_ColumnVarNameInTable="columnTongTienTheoHoaDon" msprop:Generator_ColumnPropNameInTable="TongTienTheoHoaDonColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DoiTuongKhuyenMai" />
      <xs:field xpath="mstns:ChuongTrinhKhuyenMaiID" />
      <xs:field xpath="mstns:DoiTuongNghiepVuID" />
    </xs:unique>
    <xs:unique name="ChiTietKhuyenMaiTheoThoiGian_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ChiTietKhuyenMaiTheoThoiGian" />
      <xs:field xpath="mstns:ChuongTrinhKhuyenMaiID" />
      <xs:field xpath="mstns:VatTuHangHoaID" />
    </xs:unique>
    <xs:unique name="ChuongTrinhKhuyenMai_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ChuongTrinhKhuyenMai" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="ChiTietKhuyenMaiTheoTongTienTichLuy_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ChiTietKhuyenMaiTheoTongTienTichLuy" />
      <xs:field xpath="mstns:ChuongTrinhKhuyenMaiID" />
      <xs:field xpath="mstns:TongTienTu" />
      <xs:field xpath="mstns:TongTienDen" />
    </xs:unique>
    <xs:unique name="VatTuHangHoa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:VatTuHangHoa" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
</xs:schema>